Alter Table Material add MadeInOfMaterialId bigint
go
ALTER TABLE [dbo].[Material]  WITH CHECK ADD  CONSTRAINT [FK_Material_MadeInOfMaterial] FOREIGN KEY([MadeInOfMaterialId])
REFERENCES [dbo].[MadeInOfMaterial] ([MadeInOfMaterialId])
GO

ALTER TABLE [dbo].[Material] CHECK CONSTRAINT [FK_Material_MadeInOfMaterial]
GO